package dict

var sqlInsertDics = []string{
	`SELECT COALESCE(MAX(sort_order) + 1, 1) AS maxSortOrder FROM meta_dics_#tenant_id where pid = @pi;`,
	`INSERT INTO meta_dics_#tenant_id (label, value, pid, sort_order, status) VALUES (@label, @value, @pid, @maxSortOrder, 1)`,
}

var sqlDeleteDic = `
DELETE FROM meta_dics_#tenant_id WHERE id = @id;
`

var sqlQueryAllDics = `
SELECT id, label, value, pid, sort_order, status FROM meta_dics_#tenant_id WHERE status = 1 order by pid asc,sort_order asc, id asc;
`
